

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>MySQL Repository [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Create MySQL Repository,Create,Create MySQL Repository,MySQL,MySQL Create Repository">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">MySQL Repository</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="access_2007.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="createanewsqlserverreposi.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">This feature is available in the </span><span class="f_TiporNoteText">Corporate, Business and Software Engineering, System Engineering and Ultimate editions.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">Before creating a MySQL data repository in Enterprise Architect, you must set up the MySQL and MySQL ODBC drivers. For further information on setting these up, see <a href="setupmysqlodbcdriver.htm">Setup a MySQL ODBC Driver</a>.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To create a new MySQL repository, you must first create a database into which to import the table definitions for Enterprise Architect. Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1">Registered users can obtain the scripts from the Registered Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/registered/reg_ea_corp_ed.html" target="_blank" class="weblink">www.sparxsystems.com/registered/reg_ea_corp_ed.html</a></span></li>
<li><span class="f_Bulletlist1">Trial users can obtain the scripts from the Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/resources/corporate/" target="_blank" class="weblink">http://www.sparxsystems.com/resources/corporate/</a>.</span></li>
</ul>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Create the Data Repository</span></p>
<p class="p_BodyText"><span class="f_BodyText">Once you have created the database and executed the script, you should have an empty Enterprise Architect project to begin working with. You can transfer data from an existing .EAP file or simply start from scratch.</span></p>
<p class="p_SubHeadingL2"><span class="f_SubHeadingL2">Third Party Tools</span></p>
<p class="p_BodyText"><span class="f_BodyText">If you are unfamiliar with MySQL and DBMS systems in general, you might want to consider a suitable front end tool.</span></p>
<p class="p_BodyText"><span class="f_BodyText" style="font-style: italic;">PremiumSoft Navicat</span><span class="f_BodyText"> (formerly </span><span class="f_BodyText" style="font-style: italic;">PremiumSoft MySQLStudio</span><span class="f_BodyText">) is one such tool, and is available at <a href="http://www.navicat.com/" target="_blank" class="weblink">www.navicat.com</a>. Navicat provides a convenient graphical user interface to enable the creation of databases, execution of scripts, backups and restores.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To get started with Navicat, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Create a new database.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="newmysqldb.png" width="500" height="200" border="0" alt="NewMySQLDB"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">Open and execute the MySQL script.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="createmysqldb.png" width="724" height="536" border="0" alt="CreateMySQLDB"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=3><span class="f_NumberedList">Below is an example showing the tables created in the MySQL repository after running the script in Navicat.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="navicat.png" width="822" height="557" border="0" alt="Navicat"></li>
</ol>




            </div>
          </div>
        </div>



</div>


</body>
</html>
